Advertising (Publicidad)

How to create and manage ad placements in TuPerfil.net, including positions, click tracking, and performance metrics.

The advertising section at /admin/publicidad lets you manage banner ads that appear on the public site. Each ad has an image, an optional click-through link, a position, and an active toggle.

Ad positions

Three positions are available:

Barra lateral

Appears in the right sidebar column. Suitable for square or vertical banners.

Banner superior

Appears below the site header at full width. Suitable for horizontal banners.

Entre secciones

Inserted between article category sections on the home page.

Creating an ad

1. Enter an internal name

   The Nombre field is for your reference only — it is not shown to readers. Use a descriptive name like Banner lateral - Farmacia López.

2. Upload the ad image

   Click the image upload area. The image is uploaded to Supabase Storage and its URL is saved. This field is required.

3. Set the destination link (optional)

   Enter a full URL in the Link de destino field (e.g. https://farmacialopez.com). Leave blank if the ad should not be clickable.

4. Choose the position

   Select Barra lateral, Banner superior, or Entre secciones from the Ubicación dropdown.

5. Set the display order

   The Orden number controls which ad appears first within the same position. Lower numbers appear first (0 is the highest priority).

6. Click Crear anuncio

   The ad is created with active = true by default and appears in the list below.

Managing existing ads

The ad list shows all ads grouped by position with a thumbnail, name, status badge, destination link, and performance metrics.

Activating and deactivating

Click Activar or Desactivar to toggle an ad’s visibility. Inactive ads are not shown on the public site but remain saved so you can reactivate them later.

Editing

Click Editar on any ad. The form at the top of the page fills with the ad’s current values. Make your changes and click Guardar cambios.

Deleting

Click Eliminar to permanently delete an ad. You are asked to confirm.

Performance metrics

Each ad shows impression and click counts inline:

• Impresiones — how many times the ad was displayed to a reader.
• Clicks — how many times a reader clicked the ad.
• CTR — click-through rate (clicks / impressions × 100).

The Rendimiento panel above the list aggregates totals across all ads. Use the dropdown to change the time window: Últimos 7 días, Últimos 30 días, or Últimos 90 días.

Tracking data is recorded via the ad_tracking migration (019_ad_tracking.sql). The metrics are fetched using the ad_metrics Supabase RPC function.

Ad fields reference

Field	Type	Notes
title	text	Internal name. Not shown publicly.
image_url	text	URL of the ad image in Supabase Storage.
link_url	text	Destination URL. Empty string if no link.
position	enum	sidebar, header, or between_articles.
active	boolean	Whether the ad is shown on the public site.
sort_order	integer	Display order within the same position. Lower = first.